package com.matt.repository.base;

import com.matt.domain.course.CoursePlanClasses;
import com.matt.domain.nursery.NurseryScheduleRecord;
import com.matt.foundation.DO.course.CoursePlanClassesDDO;

import java.util.Date;
import java.util.List;

/**
 * *******************************
 * Created by lch.
 * form com.matt
 * on 2018/11/27
 * *******************************
 */
public interface CoursePlanClassesNativeRepository {

    NurseryScheduleRecord findByCourseDateAndClassesIdAndCategory(String courseDateStr, String classesId, int category);

    List<CoursePlanClasses> findByCourseDateAndClassesIdAndCategoryOrderByBeginTimeDesc(Date lessonDate, String classesId, int category);
    List<CoursePlanClasses> findByKXCourseDateAndClassesIdAndCategoryOrderByBeginTimeDesc(Date lessonDate, String classesId, int category);

    List<CoursePlanClasses> findByCourseDateAndClassesIdAndBeginTimeOrderByBeginTimeDesc(Date lessonDate, String classesId,Date beginTime);

    List<CoursePlanClasses> findByCourseDateAndClassesIdOrderByBeginTimeDesc(Date lessonDate, String classesId);

    List<CoursePlanClasses> findByClassesIdAndCategoryOrderByBeginTimeDesc(Date beginDate, Date endDate, String classesId, int category);

    CoursePlanClassesDDO findByCoursePlanClassesId(String planId);
    
    public List<CoursePlanClasses> findByCourseDateAndCategoryOrderByBeginTimeDesc(Date lessonDate, int category);
}
